﻿Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient

Public Class frmkhachhang
    Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents btnNew As System.Windows.Forms.Button
    Friend WithEvents btnSave As System.Windows.Forms.Button
    Friend WithEvents btnDelete1 As System.Windows.Forms.Button
    Friend WithEvents BtnClose As System.Windows.Forms.Button
    Friend WithEvents BtnIn As System.Windows.Forms.Button
    Friend WithEvents TxtFax As System.Windows.Forms.TextBox
    Friend WithEvents TxtDienThoai As System.Windows.Forms.TextBox
    Friend WithEvents txtTen_NganHang As System.Windows.Forms.TextBox
    Friend WithEvents txtDiaChi As System.Windows.Forms.TextBox
    Friend WithEvents txtTen_KH As System.Windows.Forms.TextBox
    Friend WithEvents txtMa_KH As System.Windows.Forms.TextBox
    Friend WithEvents Label6 As System.Windows.Forms.Label
    Friend WithEvents Label5 As System.Windows.Forms.Label
    Friend WithEvents Label4 As System.Windows.Forms.Label
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents Label1 As System.Windows.Forms.Label
    'Friend WithEvents DataGridView1 As System.Windows.Forms.DataGridView
    Friend WithEvents DataGridView1 As MyDataGridView
    Friend WithEvents DiachiDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MakhachhangDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TenkhachhangDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DiachikhachhangDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents CboNhom As MTGCComboBox
    Friend WithEvents Label7 As System.Windows.Forms.Label
    Friend WithEvents TxtTen_Nhom As System.Windows.Forms.TextBox
    Friend WithEvents TxtCK As System.Windows.Forms.TextBox
    Friend WithEvents TxtVC As System.Windows.Forms.TextBox
    Friend WithEvents TxtHanNo As System.Windows.Forms.TextBox
    Friend WithEvents Label8 As System.Windows.Forms.Label
    Friend WithEvents Label9 As System.Windows.Forms.Label
    Friend WithEvents Label10 As System.Windows.Forms.Label
    Friend WithEvents Label11 As System.Windows.Forms.Label
    Friend WithEvents TxtMucNo As System.Windows.Forms.TextBox
    Friend WithEvents Label13 As System.Windows.Forms.Label
    Friend WithEvents TxtMST As System.Windows.Forms.TextBox
    Friend WithEvents TxtEmail As System.Windows.Forms.TextBox
    Friend WithEvents Label14 As System.Windows.Forms.Label
    Friend WithEvents Label15 As System.Windows.Forms.Label
    Friend WithEvents CboNganHang As MTGCComboBox
    Friend WithEvents TxtTaiKhoan As System.Windows.Forms.TextBox
    Friend WithEvents Label16 As System.Windows.Forms.Label
    Friend WithEvents Label12 As System.Windows.Forms.Label
    Friend WithEvents CboQuocGia As MTGCComboBox
    Friend WithEvents TxtTen_QuocGia As System.Windows.Forms.TextBox
    Friend WithEvents Label17 As System.Windows.Forms.Label
    Friend WithEvents CboKhuVuc As MTGCComboBox
    Friend WithEvents TxtTen_KhuVuc As System.Windows.Forms.TextBox
    Friend WithEvents Label18 As System.Windows.Forms.Label
    Friend WithEvents CboQuan As MTGCComboBox
    Friend WithEvents TxtTen_Quan As System.Windows.Forms.TextBox
    Friend WithEvents Label19 As System.Windows.Forms.Label
    Friend WithEvents CboTinh As MTGCComboBox
    Friend WithEvents TxtTen_Tinh As System.Windows.Forms.TextBox
    Friend WithEvents TabMain As System.Windows.Forms.TabControl
    Friend WithEvents TabThongtin As System.Windows.Forms.TabPage
    Friend WithEvents DataSetFormDonBindingSource As System.Windows.Forms.BindingSource
    Friend WithEvents DataSetForm_Don As MEKONG.DataSetForm_Don
    Friend WithEvents Label20 As System.Windows.Forms.Label
    Friend WithEvents txtMaSoThue As System.Windows.Forms.TextBox
    Friend WithEvents Label22 As System.Windows.Forms.Label
    Friend WithEvents Label21 As System.Windows.Forms.Label
    Friend WithEvents txtTen As System.Windows.Forms.TextBox
    Friend WithEvents txtMa As System.Windows.Forms.TextBox
    Friend WithEvents Label23 As System.Windows.Forms.Label
    Friend WithEvents txtTenNhom As System.Windows.Forms.TextBox
    Friend WithEvents cboMaNhom As MTGCComboBox
    Friend WithEvents Label24 As System.Windows.Forms.Label
    Friend WithEvents txtMaSearch As System.Windows.Forms.TextBox
    Friend WithEvents btnTimKiem As System.Windows.Forms.Button
    Friend WithEvents txtTenSearch As System.Windows.Forms.TextBox
    Friend WithEvents Label25 As System.Windows.Forms.Label
    'Friend WithEvents gridSearch As System.Windows.Forms.DataGridView
    Friend WithEvents gridSearch As MyDataGridView
    Friend WithEvents DataSetSearchBindingSource As System.Windows.Forms.BindingSource
    Friend WithEvents DataSetSearch As MEKONG.DataSetSearch
    Friend WithEvents MucnoDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ChietkhauDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents VanchuyenDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents HannoDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents txtDSPhuTrach As System.Windows.Forms.TextBox
    Friend WithEvents txtChungNhan As System.Windows.Forms.TextBox
    Friend WithEvents txtDangKy As System.Windows.Forms.TextBox
    Friend WithEvents txtDienTich As System.Windows.Forms.TextBox
    Friend WithEvents Label29 As System.Windows.Forms.Label
    Friend WithEvents Label28 As System.Windows.Forms.Label
    Friend WithEvents Label27 As System.Windows.Forms.Label
    Friend WithEvents Label26 As System.Windows.Forms.Label
    Friend WithEvents ManhacungcapDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TennhacungcapDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DiachinhacungcapDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MasothueDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DienthoaiDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents FaxDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents EmailDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents SotaikhoanDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaquocgiaDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MamienDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MatinhDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaquanDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManganhangDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManhomDataGridViewTextBoxColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents dsphutrach As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents giaychungnhan As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents giayphep As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents dientich As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManhacungcapDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TennhacungcapDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DiachinhacungcapDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MasothueDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DienthoaiDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents FaxDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents EmailDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents SotaikhoanDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaquocgiaDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MamienDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MatinhDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents MaquanDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManganhangDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ManhomDataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn1 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn2 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn3 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents DataGridViewTextBoxColumn4 As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents TabTimKiem As System.Windows.Forms.TabPage
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(frmkhachhang))
        Me.btnSave = New System.Windows.Forms.Button
        Me.btnNew = New System.Windows.Forms.Button
        Me.btnDelete1 = New System.Windows.Forms.Button
        Me.BtnClose = New System.Windows.Forms.Button
        Me.BtnIn = New System.Windows.Forms.Button
        Me.TxtFax = New System.Windows.Forms.TextBox
        Me.TxtDienThoai = New System.Windows.Forms.TextBox
        Me.txtTen_NganHang = New System.Windows.Forms.TextBox
        Me.txtDiaChi = New System.Windows.Forms.TextBox
        Me.txtTen_KH = New System.Windows.Forms.TextBox
        Me.txtMa_KH = New System.Windows.Forms.TextBox
        Me.Label6 = New System.Windows.Forms.Label
        Me.Label5 = New System.Windows.Forms.Label
        Me.Label4 = New System.Windows.Forms.Label
        Me.Label3 = New System.Windows.Forms.Label
        Me.Label2 = New System.Windows.Forms.Label
        Me.Label1 = New System.Windows.Forms.Label
        Me.DataGridView1 = New MEKONG.MyDataGridView
        Me.ManhacungcapDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TennhacungcapDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DiachinhacungcapDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MasothueDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DienthoaiDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.FaxDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.EmailDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.SotaikhoanDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaquocgiaDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MamienDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MatinhDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaquanDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManganhangDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManhomDataGridViewTextBoxColumn = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.dsphutrach = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.giaychungnhan = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.giayphep = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.dientich = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataSetFormDonBindingSource = New System.Windows.Forms.BindingSource(Me.components)
        Me.DataSetForm_Don = New MEKONG.DataSetForm_Don
        Me.CboNhom = New MTGCComboBox
        Me.Label7 = New System.Windows.Forms.Label
        Me.TxtTen_Nhom = New System.Windows.Forms.TextBox
        Me.TxtCK = New System.Windows.Forms.TextBox
        Me.TxtVC = New System.Windows.Forms.TextBox
        Me.TxtHanNo = New System.Windows.Forms.TextBox
        Me.Label8 = New System.Windows.Forms.Label
        Me.Label9 = New System.Windows.Forms.Label
        Me.Label10 = New System.Windows.Forms.Label
        Me.Label11 = New System.Windows.Forms.Label
        Me.TxtMucNo = New System.Windows.Forms.TextBox
        Me.Label13 = New System.Windows.Forms.Label
        Me.TxtMST = New System.Windows.Forms.TextBox
        Me.TxtEmail = New System.Windows.Forms.TextBox
        Me.Label14 = New System.Windows.Forms.Label
        Me.Label15 = New System.Windows.Forms.Label
        Me.CboNganHang = New MTGCComboBox
        Me.TxtTaiKhoan = New System.Windows.Forms.TextBox
        Me.Label16 = New System.Windows.Forms.Label
        Me.Label12 = New System.Windows.Forms.Label
        Me.CboQuocGia = New MTGCComboBox
        Me.TxtTen_QuocGia = New System.Windows.Forms.TextBox
        Me.Label17 = New System.Windows.Forms.Label
        Me.CboKhuVuc = New MTGCComboBox
        Me.TxtTen_KhuVuc = New System.Windows.Forms.TextBox
        Me.Label18 = New System.Windows.Forms.Label
        Me.CboQuan = New MTGCComboBox
        Me.TxtTen_Quan = New System.Windows.Forms.TextBox
        Me.Label19 = New System.Windows.Forms.Label
        Me.CboTinh = New MTGCComboBox
        Me.TxtTen_Tinh = New System.Windows.Forms.TextBox
        Me.TabMain = New System.Windows.Forms.TabControl
        Me.TabThongtin = New System.Windows.Forms.TabPage
        Me.txtDienTich = New System.Windows.Forms.TextBox
        Me.Label29 = New System.Windows.Forms.Label
        Me.Label28 = New System.Windows.Forms.Label
        Me.Label27 = New System.Windows.Forms.Label
        Me.Label26 = New System.Windows.Forms.Label
        Me.txtDSPhuTrach = New System.Windows.Forms.TextBox
        Me.txtChungNhan = New System.Windows.Forms.TextBox
        Me.txtDangKy = New System.Windows.Forms.TextBox
        Me.Label23 = New System.Windows.Forms.Label
        Me.txtTenNhom = New System.Windows.Forms.TextBox
        Me.cboMaNhom = New MTGCComboBox
        Me.Label22 = New System.Windows.Forms.Label
        Me.Label21 = New System.Windows.Forms.Label
        Me.txtTen = New System.Windows.Forms.TextBox
        Me.txtMa = New System.Windows.Forms.TextBox
        Me.Label20 = New System.Windows.Forms.Label
        Me.txtMaSoThue = New System.Windows.Forms.TextBox
        Me.TabTimKiem = New System.Windows.Forms.TabPage
        Me.Label24 = New System.Windows.Forms.Label
        Me.txtMaSearch = New System.Windows.Forms.TextBox
        Me.btnTimKiem = New System.Windows.Forms.Button
        Me.txtTenSearch = New System.Windows.Forms.TextBox
        Me.Label25 = New System.Windows.Forms.Label
        Me.gridSearch = New MEKONG.MyDataGridView
        Me.ManhacungcapDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.TennhacungcapDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DiachinhacungcapDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MasothueDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DienthoaiDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.FaxDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.EmailDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.SotaikhoanDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaquocgiaDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MamienDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MatinhDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.MaquanDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManganhangDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.ManhomDataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn1 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn2 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn3 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataGridViewTextBoxColumn4 = New System.Windows.Forms.DataGridViewTextBoxColumn
        Me.DataSetSearchBindingSource = New System.Windows.Forms.BindingSource(Me.components)
        Me.DataSetSearch = New MEKONG.DataSetSearch
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetFormDonBindingSource, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetForm_Don, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.TabMain.SuspendLayout()
        Me.TabThongtin.SuspendLayout()
        Me.TabTimKiem.SuspendLayout()
        CType(Me.gridSearch, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetSearchBindingSource, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.DataSetSearch, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'btnSave
        '
        Me.btnSave.BackColor = System.Drawing.Color.Transparent
        Me.btnSave.Image = CType(resources.GetObject("btnSave.Image"), System.Drawing.Image)
        Me.btnSave.Location = New System.Drawing.Point(338, 542)
        Me.btnSave.Name = "btnSave"
        Me.btnSave.Size = New System.Drawing.Size(96, 24)
        Me.btnSave.TabIndex = 18
        Me.btnSave.UseVisualStyleBackColor = False
        '
        'btnNew
        '
        Me.btnNew.Image = CType(resources.GetObject("btnNew.Image"), System.Drawing.Image)
        Me.btnNew.Location = New System.Drawing.Point(218, 542)
        Me.btnNew.Name = "btnNew"
        Me.btnNew.Size = New System.Drawing.Size(96, 24)
        Me.btnNew.TabIndex = 12
        '
        'btnDelete1
        '
        Me.btnDelete1.Image = CType(resources.GetObject("btnDelete1.Image"), System.Drawing.Image)
        Me.btnDelete1.Location = New System.Drawing.Point(458, 542)
        Me.btnDelete1.Name = "btnDelete1"
        Me.btnDelete1.Size = New System.Drawing.Size(88, 24)
        Me.btnDelete1.TabIndex = 29
        '
        'BtnClose
        '
        Me.BtnClose.Image = CType(resources.GetObject("BtnClose.Image"), System.Drawing.Image)
        Me.BtnClose.Location = New System.Drawing.Point(690, 542)
        Me.BtnClose.Name = "BtnClose"
        Me.BtnClose.Size = New System.Drawing.Size(88, 24)
        Me.BtnClose.TabIndex = 30
        '
        'BtnIn
        '
        Me.BtnIn.Image = CType(resources.GetObject("BtnIn.Image"), System.Drawing.Image)
        Me.BtnIn.Location = New System.Drawing.Point(578, 542)
        Me.BtnIn.Name = "BtnIn"
        Me.BtnIn.Size = New System.Drawing.Size(88, 24)
        Me.BtnIn.TabIndex = 19
        '
        'TxtFax
        '
        Me.TxtFax.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.TxtFax.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtFax.Location = New System.Drawing.Point(338, 83)
        Me.TxtFax.MaxLength = 50
        Me.TxtFax.Name = "TxtFax"
        Me.TxtFax.Size = New System.Drawing.Size(180, 22)
        Me.TxtFax.TabIndex = 8
        '
        'TxtDienThoai
        '
        Me.TxtDienThoai.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtDienThoai.Location = New System.Drawing.Point(100, 83)
        Me.TxtDienThoai.MaxLength = 50
        Me.TxtDienThoai.Name = "TxtDienThoai"
        Me.TxtDienThoai.Size = New System.Drawing.Size(199, 22)
        Me.TxtDienThoai.TabIndex = 7
        '
        'txtTen_NganHang
        '
        Me.txtTen_NganHang.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTen_NganHang.Location = New System.Drawing.Point(221, 111)
        Me.txtTen_NganHang.MaxLength = 50
        Me.txtTen_NganHang.Name = "txtTen_NganHang"
        Me.txtTen_NganHang.Size = New System.Drawing.Size(297, 22)
        Me.txtTen_NganHang.TabIndex = 101
        '
        'txtDiaChi
        '
        Me.txtDiaChi.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtDiaChi.Location = New System.Drawing.Point(100, 56)
        Me.txtDiaChi.MaxLength = 100
        Me.txtDiaChi.Name = "txtDiaChi"
        Me.txtDiaChi.Size = New System.Drawing.Size(418, 22)
        Me.txtDiaChi.TabIndex = 5
        '
        'txtTen_KH
        '
        Me.txtTen_KH.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTen_KH.Location = New System.Drawing.Point(85, -74)
        Me.txtTen_KH.MaxLength = 50
        Me.txtTen_KH.Name = "txtTen_KH"
        Me.txtTen_KH.Size = New System.Drawing.Size(376, 22)
        Me.txtTen_KH.TabIndex = 2
        '
        'txtMa_KH
        '
        Me.txtMa_KH.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtMa_KH.Location = New System.Drawing.Point(85, -102)
        Me.txtMa_KH.MaxLength = 10
        Me.txtMa_KH.Name = "txtMa_KH"
        Me.txtMa_KH.Size = New System.Drawing.Size(122, 22)
        Me.txtMa_KH.TabIndex = 1
        '
        'Label6
        '
        Me.Label6.Location = New System.Drawing.Point(305, 83)
        Me.Label6.Name = "Label6"
        Me.Label6.Size = New System.Drawing.Size(27, 22)
        Me.Label6.TabIndex = 68
        Me.Label6.Text = "Fax"
        Me.Label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label5
        '
        Me.Label5.Location = New System.Drawing.Point(33, 83)
        Me.Label5.Name = "Label5"
        Me.Label5.Size = New System.Drawing.Size(61, 22)
        Me.Label5.TabIndex = 67
        Me.Label5.Text = "Điện thoại"
        Me.Label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(33, 56)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(61, 22)
        Me.Label4.TabIndex = 64
        Me.Label4.Text = "Địa chỉ KH"
        Me.Label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label3
        '
        Me.Label3.Location = New System.Drawing.Point(-5, -71)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(88, 18)
        Me.Label3.TabIndex = 63
        Me.Label3.Text = "Tên Khách hàng"
        Me.Label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label2
        '
        Me.Label2.Location = New System.Drawing.Point(1, -102)
        Me.Label2.Name = "Label2"
        Me.Label2.Size = New System.Drawing.Size(82, 21)
        Me.Label2.TabIndex = 62
        Me.Label2.Text = "Mã Khách hàng"
        Me.Label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label1
        '
        Me.Label1.BackColor = System.Drawing.Color.Transparent
        Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 15.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.Label1.Location = New System.Drawing.Point(322, 4)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(304, 24)
        Me.Label1.TabIndex = 60
        Me.Label1.Text = "DANH MỤC KHÁCH HÀNG"
        '
        'DataGridView1
        '
        Me.DataGridView1.AllowUserToAddRows = False
        Me.DataGridView1.AllowUserToDeleteRows = False
        Me.DataGridView1.AllowUserToResizeColumns = False
        Me.DataGridView1.AutoGenerateColumns = False
        Me.DataGridView1.BackgroundColor = System.Drawing.Color.LightBlue
        Me.DataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.DataGridView1.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn() {Me.ManhacungcapDataGridViewTextBoxColumn, Me.TennhacungcapDataGridViewTextBoxColumn, Me.DiachinhacungcapDataGridViewTextBoxColumn, Me.MasothueDataGridViewTextBoxColumn, Me.DienthoaiDataGridViewTextBoxColumn, Me.FaxDataGridViewTextBoxColumn, Me.EmailDataGridViewTextBoxColumn, Me.SotaikhoanDataGridViewTextBoxColumn, Me.MaquocgiaDataGridViewTextBoxColumn, Me.MamienDataGridViewTextBoxColumn, Me.MatinhDataGridViewTextBoxColumn, Me.MaquanDataGridViewTextBoxColumn, Me.ManganhangDataGridViewTextBoxColumn, Me.ManhomDataGridViewTextBoxColumn, Me.dsphutrach, Me.giaychungnhan, Me.giayphep, Me.dientich})
        Me.DataGridView1.DataMember = "tbl_khachhang"
        Me.DataGridView1.DataSource = Me.DataSetFormDonBindingSource
        Me.DataGridView1.Location = New System.Drawing.Point(6, 222)
        Me.DataGridView1.Name = "DataGridView1"
        Me.DataGridView1.ReadOnly = True
        Me.DataGridView1.Size = New System.Drawing.Size(972, 314)
        Me.DataGridView1.TabIndex = 75
        '
        'ManhacungcapDataGridViewTextBoxColumn
        '
        Me.ManhacungcapDataGridViewTextBoxColumn.DataPropertyName = "ma_nhacungcap"
        Me.ManhacungcapDataGridViewTextBoxColumn.HeaderText = "Mã KH"
        Me.ManhacungcapDataGridViewTextBoxColumn.Name = "ManhacungcapDataGridViewTextBoxColumn"
        Me.ManhacungcapDataGridViewTextBoxColumn.ReadOnly = True
        '
        'TennhacungcapDataGridViewTextBoxColumn
        '
        Me.TennhacungcapDataGridViewTextBoxColumn.DataPropertyName = "ten_nhacungcap"
        Me.TennhacungcapDataGridViewTextBoxColumn.HeaderText = "Tên KH"
        Me.TennhacungcapDataGridViewTextBoxColumn.Name = "TennhacungcapDataGridViewTextBoxColumn"
        Me.TennhacungcapDataGridViewTextBoxColumn.ReadOnly = True
        Me.TennhacungcapDataGridViewTextBoxColumn.Width = 220
        '
        'DiachinhacungcapDataGridViewTextBoxColumn
        '
        Me.DiachinhacungcapDataGridViewTextBoxColumn.DataPropertyName = "diachi_nhacungcap"
        Me.DiachinhacungcapDataGridViewTextBoxColumn.HeaderText = "Địa chỉ"
        Me.DiachinhacungcapDataGridViewTextBoxColumn.Name = "DiachinhacungcapDataGridViewTextBoxColumn"
        Me.DiachinhacungcapDataGridViewTextBoxColumn.ReadOnly = True
        Me.DiachinhacungcapDataGridViewTextBoxColumn.Width = 190
        '
        'MasothueDataGridViewTextBoxColumn
        '
        Me.MasothueDataGridViewTextBoxColumn.DataPropertyName = "maso_thue"
        Me.MasothueDataGridViewTextBoxColumn.HeaderText = "MST"
        Me.MasothueDataGridViewTextBoxColumn.Name = "MasothueDataGridViewTextBoxColumn"
        Me.MasothueDataGridViewTextBoxColumn.ReadOnly = True
        '
        'DienthoaiDataGridViewTextBoxColumn
        '
        Me.DienthoaiDataGridViewTextBoxColumn.DataPropertyName = "dienthoai"
        Me.DienthoaiDataGridViewTextBoxColumn.HeaderText = "DT"
        Me.DienthoaiDataGridViewTextBoxColumn.Name = "DienthoaiDataGridViewTextBoxColumn"
        Me.DienthoaiDataGridViewTextBoxColumn.ReadOnly = True
        '
        'FaxDataGridViewTextBoxColumn
        '
        Me.FaxDataGridViewTextBoxColumn.DataPropertyName = "fax"
        Me.FaxDataGridViewTextBoxColumn.HeaderText = "FAX"
        Me.FaxDataGridViewTextBoxColumn.Name = "FaxDataGridViewTextBoxColumn"
        Me.FaxDataGridViewTextBoxColumn.ReadOnly = True
        '
        'EmailDataGridViewTextBoxColumn
        '
        Me.EmailDataGridViewTextBoxColumn.DataPropertyName = "email"
        Me.EmailDataGridViewTextBoxColumn.HeaderText = "Ẹmail"
        Me.EmailDataGridViewTextBoxColumn.Name = "EmailDataGridViewTextBoxColumn"
        Me.EmailDataGridViewTextBoxColumn.ReadOnly = True
        '
        'SotaikhoanDataGridViewTextBoxColumn
        '
        Me.SotaikhoanDataGridViewTextBoxColumn.DataPropertyName = "so_taikhoan"
        Me.SotaikhoanDataGridViewTextBoxColumn.HeaderText = "so_taikhoan"
        Me.SotaikhoanDataGridViewTextBoxColumn.Name = "SotaikhoanDataGridViewTextBoxColumn"
        Me.SotaikhoanDataGridViewTextBoxColumn.ReadOnly = True
        Me.SotaikhoanDataGridViewTextBoxColumn.Visible = False
        '
        'MaquocgiaDataGridViewTextBoxColumn
        '
        Me.MaquocgiaDataGridViewTextBoxColumn.DataPropertyName = "ma_quocgia"
        Me.MaquocgiaDataGridViewTextBoxColumn.HeaderText = "ma_quocgia"
        Me.MaquocgiaDataGridViewTextBoxColumn.Name = "MaquocgiaDataGridViewTextBoxColumn"
        Me.MaquocgiaDataGridViewTextBoxColumn.ReadOnly = True
        Me.MaquocgiaDataGridViewTextBoxColumn.Visible = False
        '
        'MamienDataGridViewTextBoxColumn
        '
        Me.MamienDataGridViewTextBoxColumn.DataPropertyName = "ma_mien"
        Me.MamienDataGridViewTextBoxColumn.HeaderText = "Mã miền"
        Me.MamienDataGridViewTextBoxColumn.Name = "MamienDataGridViewTextBoxColumn"
        Me.MamienDataGridViewTextBoxColumn.ReadOnly = True
        Me.MamienDataGridViewTextBoxColumn.Width = 70
        '
        'MatinhDataGridViewTextBoxColumn
        '
        Me.MatinhDataGridViewTextBoxColumn.DataPropertyName = "ma_tinh"
        Me.MatinhDataGridViewTextBoxColumn.HeaderText = "Tỉnh"
        Me.MatinhDataGridViewTextBoxColumn.Name = "MatinhDataGridViewTextBoxColumn"
        Me.MatinhDataGridViewTextBoxColumn.ReadOnly = True
        Me.MatinhDataGridViewTextBoxColumn.Width = 60
        '
        'MaquanDataGridViewTextBoxColumn
        '
        Me.MaquanDataGridViewTextBoxColumn.DataPropertyName = "ma_quan"
        Me.MaquanDataGridViewTextBoxColumn.HeaderText = "Quận"
        Me.MaquanDataGridViewTextBoxColumn.Name = "MaquanDataGridViewTextBoxColumn"
        Me.MaquanDataGridViewTextBoxColumn.ReadOnly = True
        Me.MaquanDataGridViewTextBoxColumn.Width = 60
        '
        'ManganhangDataGridViewTextBoxColumn
        '
        Me.ManganhangDataGridViewTextBoxColumn.DataPropertyName = "ma_nganhang"
        Me.ManganhangDataGridViewTextBoxColumn.HeaderText = "ma_nganhang"
        Me.ManganhangDataGridViewTextBoxColumn.Name = "ManganhangDataGridViewTextBoxColumn"
        Me.ManganhangDataGridViewTextBoxColumn.ReadOnly = True
        Me.ManganhangDataGridViewTextBoxColumn.Visible = False
        '
        'ManhomDataGridViewTextBoxColumn
        '
        Me.ManhomDataGridViewTextBoxColumn.DataPropertyName = "ma_nhom"
        Me.ManhomDataGridViewTextBoxColumn.HeaderText = "Nhóm"
        Me.ManhomDataGridViewTextBoxColumn.Name = "ManhomDataGridViewTextBoxColumn"
        Me.ManhomDataGridViewTextBoxColumn.ReadOnly = True
        Me.ManhomDataGridViewTextBoxColumn.Width = 60
        '
        'dsphutrach
        '
        Me.dsphutrach.DataPropertyName = "dsphutrach"
        Me.dsphutrach.HeaderText = "dsphutrach"
        Me.dsphutrach.Name = "dsphutrach"
        Me.dsphutrach.ReadOnly = True
        Me.dsphutrach.Visible = False
        '
        'giaychungnhan
        '
        Me.giaychungnhan.DataPropertyName = "giaychungnhan"
        Me.giaychungnhan.HeaderText = "giaychungnhan"
        Me.giaychungnhan.Name = "giaychungnhan"
        Me.giaychungnhan.ReadOnly = True
        Me.giaychungnhan.Visible = False
        '
        'giayphep
        '
        Me.giayphep.DataPropertyName = "giayphep"
        Me.giayphep.HeaderText = "giayphep"
        Me.giayphep.Name = "giayphep"
        Me.giayphep.ReadOnly = True
        Me.giayphep.Visible = False
        '
        'dientich
        '
        Me.dientich.DataPropertyName = "dientich"
        Me.dientich.HeaderText = "dientich"
        Me.dientich.Name = "dientich"
        Me.dientich.ReadOnly = True
        Me.dientich.Visible = False
        '
        'DataSetFormDonBindingSource
        '
        Me.DataSetFormDonBindingSource.DataSource = Me.DataSetForm_Don
        Me.DataSetFormDonBindingSource.Position = 0
        '
        'DataSetForm_Don
        '
        Me.DataSetForm_Don.DataSetName = "DataSetForm_Don"
        Me.DataSetForm_Don.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
        '
        'CboNhom
        '
        Me.CboNhom.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhom.ArrowColor = System.Drawing.Color.Black
        Me.CboNhom.BindedControl = Nothing
        Me.CboNhom.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboNhom.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboNhom.ColumnNum = 1
        Me.CboNhom.ColumnWidth = "121"
        Me.CboNhom.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNhom.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboNhom.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboNhom.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboNhom.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboNhom.DisplayMember = "Text"
        Me.CboNhom.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboNhom.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboNhom.DropDownForeColor = System.Drawing.Color.Black
        Me.CboNhom.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboNhom.DropDownWidth = 141
        Me.CboNhom.GridLineColor = System.Drawing.Color.LightGray
        Me.CboNhom.GridLineHorizontal = False
        Me.CboNhom.GridLineVertical = False
        Me.CboNhom.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboNhom.Location = New System.Drawing.Point(86, -129)
        Me.CboNhom.ManagingFastMouseMoving = True
        Me.CboNhom.ManagingFastMouseMovingInterval = 30
        Me.CboNhom.Name = "CboNhom"
        Me.CboNhom.SelectedItem = Nothing
        Me.CboNhom.SelectedValue = Nothing
        Me.CboNhom.Size = New System.Drawing.Size(121, 21)
        Me.CboNhom.TabIndex = 76
        '
        'Label7
        '
        Me.Label7.Location = New System.Drawing.Point(6, -129)
        Me.Label7.Name = "Label7"
        Me.Label7.Size = New System.Drawing.Size(78, 21)
        Me.Label7.TabIndex = 77
        Me.Label7.Text = "Mã Nhóm KH"
        Me.Label7.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'TxtTen_Nhom
        '
        Me.TxtTen_Nhom.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTen_Nhom.Location = New System.Drawing.Point(206, -129)
        Me.TxtTen_Nhom.MaxLength = 50
        Me.TxtTen_Nhom.Name = "TxtTen_Nhom"
        Me.TxtTen_Nhom.Size = New System.Drawing.Size(449, 22)
        Me.TxtTen_Nhom.TabIndex = 78
        '
        'TxtCK
        '
        Me.TxtCK.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtCK.Location = New System.Drawing.Point(254, -101)
        Me.TxtCK.MaxLength = 10
        Me.TxtCK.Name = "TxtCK"
        Me.TxtCK.Size = New System.Drawing.Size(29, 22)
        Me.TxtCK.TabIndex = 79
        '
        'TxtVC
        '
        Me.TxtVC.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtVC.Location = New System.Drawing.Point(330, -101)
        Me.TxtVC.MaxLength = 10
        Me.TxtVC.Name = "TxtVC"
        Me.TxtVC.Size = New System.Drawing.Size(32, 22)
        Me.TxtVC.TabIndex = 80
        '
        'TxtHanNo
        '
        Me.TxtHanNo.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtHanNo.Location = New System.Drawing.Point(424, -101)
        Me.TxtHanNo.MaxLength = 10
        Me.TxtHanNo.Name = "TxtHanNo"
        Me.TxtHanNo.Size = New System.Drawing.Size(36, 22)
        Me.TxtHanNo.TabIndex = 81
        '
        'Label8
        '
        Me.Label8.Location = New System.Drawing.Point(212, -99)
        Me.Label8.Name = "Label8"
        Me.Label8.Size = New System.Drawing.Size(40, 21)
        Me.Label8.TabIndex = 82
        Me.Label8.Text = "CK(%)"
        Me.Label8.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label9
        '
        Me.Label9.Location = New System.Drawing.Point(289, -101)
        Me.Label9.Name = "Label9"
        Me.Label9.Size = New System.Drawing.Size(40, 21)
        Me.Label9.TabIndex = 83
        Me.Label9.Text = "VC(%)"
        Me.Label9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label10
        '
        Me.Label10.Location = New System.Drawing.Point(369, -99)
        Me.Label10.Name = "Label10"
        Me.Label10.Size = New System.Drawing.Size(48, 21)
        Me.Label10.TabIndex = 84
        Me.Label10.Text = "Hạn Nợ"
        Me.Label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label11
        '
        Me.Label11.Location = New System.Drawing.Point(466, -101)
        Me.Label11.Name = "Label11"
        Me.Label11.Size = New System.Drawing.Size(57, 21)
        Me.Label11.TabIndex = 86
        Me.Label11.Text = "Mức Nợ"
        Me.Label11.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'TxtMucNo
        '
        Me.TxtMucNo.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtMucNo.Location = New System.Drawing.Point(520, -100)
        Me.TxtMucNo.MaxLength = 10
        Me.TxtMucNo.Name = "TxtMucNo"
        Me.TxtMucNo.Size = New System.Drawing.Size(135, 22)
        Me.TxtMucNo.TabIndex = 85
        '
        'Label13
        '
        Me.Label13.Location = New System.Drawing.Point(471, -73)
        Me.Label13.Name = "Label13"
        Me.Label13.Size = New System.Drawing.Size(43, 21)
        Me.Label13.TabIndex = 88
        Me.Label13.Text = "MST"
        Me.Label13.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'TxtMST
        '
        Me.TxtMST.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtMST.Location = New System.Drawing.Point(520, -73)
        Me.TxtMST.MaxLength = 10
        Me.TxtMST.Name = "TxtMST"
        Me.TxtMST.Size = New System.Drawing.Size(135, 22)
        Me.TxtMST.TabIndex = 87
        '
        'TxtEmail
        '
        Me.TxtEmail.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.TxtEmail.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtEmail.Location = New System.Drawing.Point(618, 85)
        Me.TxtEmail.MaxLength = 50
        Me.TxtEmail.Name = "TxtEmail"
        Me.TxtEmail.Size = New System.Drawing.Size(343, 22)
        Me.TxtEmail.TabIndex = 9
        '
        'Label14
        '
        Me.Label14.Location = New System.Drawing.Point(526, 83)
        Me.Label14.Name = "Label14"
        Me.Label14.Size = New System.Drawing.Size(85, 22)
        Me.Label14.TabIndex = 90
        Me.Label14.Text = "Địa chỉ Email"
        Me.Label14.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label15
        '
        Me.Label15.Location = New System.Drawing.Point(33, 114)
        Me.Label15.Name = "Label15"
        Me.Label15.Size = New System.Drawing.Size(61, 19)
        Me.Label15.TabIndex = 92
        Me.Label15.Text = "Ngân hàng"
        Me.Label15.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'CboNganHang
        '
        Me.CboNganHang.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNganHang.ArrowColor = System.Drawing.Color.Black
        Me.CboNganHang.BindedControl = Nothing
        Me.CboNganHang.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboNganHang.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboNganHang.ColumnNum = 1
        Me.CboNganHang.ColumnWidth = "121"
        Me.CboNganHang.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboNganHang.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboNganHang.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboNganHang.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboNganHang.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboNganHang.DisplayMember = "Text"
        Me.CboNganHang.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboNganHang.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboNganHang.DropDownForeColor = System.Drawing.Color.Black
        Me.CboNganHang.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboNganHang.DropDownWidth = 141
        Me.CboNganHang.GridLineColor = System.Drawing.Color.LightGray
        Me.CboNganHang.GridLineHorizontal = False
        Me.CboNganHang.GridLineVertical = False
        Me.CboNganHang.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboNganHang.Location = New System.Drawing.Point(100, 111)
        Me.CboNganHang.ManagingFastMouseMoving = True
        Me.CboNganHang.ManagingFastMouseMovingInterval = 30
        Me.CboNganHang.Name = "CboNganHang"
        Me.CboNganHang.SelectedItem = Nothing
        Me.CboNganHang.SelectedValue = Nothing
        Me.CboNganHang.Size = New System.Drawing.Size(121, 21)
        Me.CboNganHang.TabIndex = 10
        '
        'TxtTaiKhoan
        '
        Me.TxtTaiKhoan.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.TxtTaiKhoan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTaiKhoan.Location = New System.Drawing.Point(618, 113)
        Me.TxtTaiKhoan.MaxLength = 50
        Me.TxtTaiKhoan.Name = "TxtTaiKhoan"
        Me.TxtTaiKhoan.Size = New System.Drawing.Size(343, 22)
        Me.TxtTaiKhoan.TabIndex = 11
        '
        'Label16
        '
        Me.Label16.Location = New System.Drawing.Point(527, 114)
        Me.Label16.Name = "Label16"
        Me.Label16.Size = New System.Drawing.Size(85, 22)
        Me.Label16.TabIndex = 94
        Me.Label16.Text = "Tài khoản số"
        Me.Label16.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label12
        '
        Me.Label12.Location = New System.Drawing.Point(16, 168)
        Me.Label12.Name = "Label12"
        Me.Label12.Size = New System.Drawing.Size(77, 19)
        Me.Label12.TabIndex = 97
        Me.Label12.Text = "Tên Quốc Gia"
        Me.Label12.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'CboQuocGia
        '
        Me.CboQuocGia.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboQuocGia.ArrowColor = System.Drawing.Color.Black
        Me.CboQuocGia.BindedControl = Nothing
        Me.CboQuocGia.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboQuocGia.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboQuocGia.ColumnNum = 1
        Me.CboQuocGia.ColumnWidth = "121"
        Me.CboQuocGia.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboQuocGia.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboQuocGia.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboQuocGia.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboQuocGia.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboQuocGia.DisplayMember = "Text"
        Me.CboQuocGia.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboQuocGia.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboQuocGia.DropDownForeColor = System.Drawing.Color.Black
        Me.CboQuocGia.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboQuocGia.DropDownWidth = 141
        Me.CboQuocGia.GridLineColor = System.Drawing.Color.LightGray
        Me.CboQuocGia.GridLineHorizontal = False
        Me.CboQuocGia.GridLineVertical = False
        Me.CboQuocGia.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboQuocGia.Location = New System.Drawing.Point(100, 165)
        Me.CboQuocGia.ManagingFastMouseMoving = True
        Me.CboQuocGia.ManagingFastMouseMovingInterval = 30
        Me.CboQuocGia.Name = "CboQuocGia"
        Me.CboQuocGia.SelectedItem = Nothing
        Me.CboQuocGia.SelectedValue = Nothing
        Me.CboQuocGia.Size = New System.Drawing.Size(75, 21)
        Me.CboQuocGia.TabIndex = 14
        '
        'TxtTen_QuocGia
        '
        Me.TxtTen_QuocGia.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTen_QuocGia.Location = New System.Drawing.Point(176, 165)
        Me.TxtTen_QuocGia.MaxLength = 50
        Me.TxtTen_QuocGia.Name = "TxtTen_QuocGia"
        Me.TxtTen_QuocGia.Size = New System.Drawing.Size(342, 22)
        Me.TxtTen_QuocGia.TabIndex = 95
        '
        'Label17
        '
        Me.Label17.Location = New System.Drawing.Point(543, 168)
        Me.Label17.Name = "Label17"
        Me.Label17.Size = New System.Drawing.Size(66, 19)
        Me.Label17.TabIndex = 100
        Me.Label17.Text = "Khu vực"
        Me.Label17.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'CboKhuVuc
        '
        Me.CboKhuVuc.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboKhuVuc.ArrowColor = System.Drawing.Color.Black
        Me.CboKhuVuc.BindedControl = Nothing
        Me.CboKhuVuc.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboKhuVuc.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboKhuVuc.ColumnNum = 1
        Me.CboKhuVuc.ColumnWidth = "121"
        Me.CboKhuVuc.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboKhuVuc.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboKhuVuc.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboKhuVuc.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboKhuVuc.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboKhuVuc.DisplayMember = "Text"
        Me.CboKhuVuc.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboKhuVuc.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboKhuVuc.DropDownForeColor = System.Drawing.Color.Black
        Me.CboKhuVuc.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboKhuVuc.DropDownWidth = 141
        Me.CboKhuVuc.GridLineColor = System.Drawing.Color.LightGray
        Me.CboKhuVuc.GridLineHorizontal = False
        Me.CboKhuVuc.GridLineVertical = False
        Me.CboKhuVuc.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboKhuVuc.Location = New System.Drawing.Point(618, 169)
        Me.CboKhuVuc.ManagingFastMouseMoving = True
        Me.CboKhuVuc.ManagingFastMouseMovingInterval = 30
        Me.CboKhuVuc.Name = "CboKhuVuc"
        Me.CboKhuVuc.SelectedItem = Nothing
        Me.CboKhuVuc.SelectedValue = Nothing
        Me.CboKhuVuc.Size = New System.Drawing.Size(75, 21)
        Me.CboKhuVuc.TabIndex = 15
        '
        'TxtTen_KhuVuc
        '
        Me.TxtTen_KhuVuc.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTen_KhuVuc.Location = New System.Drawing.Point(693, 168)
        Me.TxtTen_KhuVuc.MaxLength = 50
        Me.TxtTen_KhuVuc.Name = "TxtTen_KhuVuc"
        Me.TxtTen_KhuVuc.Size = New System.Drawing.Size(268, 22)
        Me.TxtTen_KhuVuc.TabIndex = 98
        '
        'Label18
        '
        Me.Label18.Location = New System.Drawing.Point(510, 194)
        Me.Label18.Name = "Label18"
        Me.Label18.Size = New System.Drawing.Size(100, 19)
        Me.Label18.TabIndex = 106
        Me.Label18.Text = "Quận / Huyện"
        Me.Label18.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'CboQuan
        '
        Me.CboQuan.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboQuan.ArrowColor = System.Drawing.Color.Black
        Me.CboQuan.BindedControl = Nothing
        Me.CboQuan.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboQuan.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboQuan.ColumnNum = 1
        Me.CboQuan.ColumnWidth = "121"
        Me.CboQuan.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboQuan.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboQuan.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboQuan.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboQuan.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboQuan.DisplayMember = "Text"
        Me.CboQuan.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboQuan.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboQuan.DropDownForeColor = System.Drawing.Color.Black
        Me.CboQuan.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboQuan.DropDownWidth = 141
        Me.CboQuan.GridLineColor = System.Drawing.Color.LightGray
        Me.CboQuan.GridLineHorizontal = False
        Me.CboQuan.GridLineVertical = False
        Me.CboQuan.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboQuan.Location = New System.Drawing.Point(618, 196)
        Me.CboQuan.ManagingFastMouseMoving = True
        Me.CboQuan.ManagingFastMouseMovingInterval = 30
        Me.CboQuan.Name = "CboQuan"
        Me.CboQuan.SelectedItem = Nothing
        Me.CboQuan.SelectedValue = Nothing
        Me.CboQuan.Size = New System.Drawing.Size(75, 21)
        Me.CboQuan.TabIndex = 17
        '
        'TxtTen_Quan
        '
        Me.TxtTen_Quan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTen_Quan.Location = New System.Drawing.Point(693, 195)
        Me.TxtTen_Quan.MaxLength = 50
        Me.TxtTen_Quan.Name = "TxtTen_Quan"
        Me.TxtTen_Quan.Size = New System.Drawing.Size(268, 22)
        Me.TxtTen_Quan.TabIndex = 104
        '
        'Label19
        '
        Me.Label19.Location = New System.Drawing.Point(32, 194)
        Me.Label19.Name = "Label19"
        Me.Label19.Size = New System.Drawing.Size(61, 19)
        Me.Label19.TabIndex = 103
        Me.Label19.Text = "Tỉnh/Thành"
        Me.Label19.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'CboTinh
        '
        Me.CboTinh.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboTinh.ArrowColor = System.Drawing.Color.Black
        Me.CboTinh.BindedControl = Nothing
        Me.CboTinh.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.CboTinh.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.CboTinh.ColumnNum = 1
        Me.CboTinh.ColumnWidth = "121"
        Me.CboTinh.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.CboTinh.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.CboTinh.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.CboTinh.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.CboTinh.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.CboTinh.DisplayMember = "Text"
        Me.CboTinh.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.CboTinh.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.CboTinh.DropDownForeColor = System.Drawing.Color.Black
        Me.CboTinh.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.CboTinh.DropDownWidth = 141
        Me.CboTinh.GridLineColor = System.Drawing.Color.LightGray
        Me.CboTinh.GridLineHorizontal = False
        Me.CboTinh.GridLineVertical = False
        Me.CboTinh.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.CboTinh.Location = New System.Drawing.Point(100, 192)
        Me.CboTinh.ManagingFastMouseMoving = True
        Me.CboTinh.ManagingFastMouseMovingInterval = 30
        Me.CboTinh.Name = "CboTinh"
        Me.CboTinh.SelectedItem = Nothing
        Me.CboTinh.SelectedValue = Nothing
        Me.CboTinh.Size = New System.Drawing.Size(75, 21)
        Me.CboTinh.TabIndex = 16
        '
        'TxtTen_Tinh
        '
        Me.TxtTen_Tinh.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TxtTen_Tinh.Location = New System.Drawing.Point(176, 192)
        Me.TxtTen_Tinh.MaxLength = 50
        Me.TxtTen_Tinh.Name = "TxtTen_Tinh"
        Me.TxtTen_Tinh.Size = New System.Drawing.Size(342, 22)
        Me.TxtTen_Tinh.TabIndex = 101
        '
        'TabMain
        '
        Me.TabMain.Controls.Add(Me.TabThongtin)
        Me.TabMain.Controls.Add(Me.TabTimKiem)
        Me.TabMain.Location = New System.Drawing.Point(-7, 32)
        Me.TabMain.Name = "TabMain"
        Me.TabMain.SelectedIndex = 0
        Me.TabMain.Size = New System.Drawing.Size(992, 601)
        Me.TabMain.TabIndex = 107
        '
        'TabThongtin
        '
        Me.TabThongtin.BackColor = System.Drawing.Color.LightBlue
        Me.TabThongtin.Controls.Add(Me.txtDienTich)
        Me.TabThongtin.Controls.Add(Me.Label29)
        Me.TabThongtin.Controls.Add(Me.Label28)
        Me.TabThongtin.Controls.Add(Me.Label27)
        Me.TabThongtin.Controls.Add(Me.Label26)
        Me.TabThongtin.Controls.Add(Me.txtDSPhuTrach)
        Me.TabThongtin.Controls.Add(Me.txtChungNhan)
        Me.TabThongtin.Controls.Add(Me.txtDangKy)
        Me.TabThongtin.Controls.Add(Me.Label23)
        Me.TabThongtin.Controls.Add(Me.txtTenNhom)
        Me.TabThongtin.Controls.Add(Me.cboMaNhom)
        Me.TabThongtin.Controls.Add(Me.Label22)
        Me.TabThongtin.Controls.Add(Me.Label21)
        Me.TabThongtin.Controls.Add(Me.txtTen)
        Me.TabThongtin.Controls.Add(Me.txtMa)
        Me.TabThongtin.Controls.Add(Me.Label20)
        Me.TabThongtin.Controls.Add(Me.txtMaSoThue)
        Me.TabThongtin.Controls.Add(Me.BtnIn)
        Me.TabThongtin.Controls.Add(Me.Label18)
        Me.TabThongtin.Controls.Add(Me.btnSave)
        Me.TabThongtin.Controls.Add(Me.CboQuan)
        Me.TabThongtin.Controls.Add(Me.btnNew)
        Me.TabThongtin.Controls.Add(Me.TxtTen_Quan)
        Me.TabThongtin.Controls.Add(Me.btnDelete1)
        Me.TabThongtin.Controls.Add(Me.Label19)
        Me.TabThongtin.Controls.Add(Me.BtnClose)
        Me.TabThongtin.Controls.Add(Me.CboTinh)
        Me.TabThongtin.Controls.Add(Me.Label2)
        Me.TabThongtin.Controls.Add(Me.TxtTen_Tinh)
        Me.TabThongtin.Controls.Add(Me.Label3)
        Me.TabThongtin.Controls.Add(Me.Label17)
        Me.TabThongtin.Controls.Add(Me.Label4)
        Me.TabThongtin.Controls.Add(Me.CboKhuVuc)
        Me.TabThongtin.Controls.Add(Me.Label5)
        Me.TabThongtin.Controls.Add(Me.TxtTen_KhuVuc)
        Me.TabThongtin.Controls.Add(Me.Label6)
        Me.TabThongtin.Controls.Add(Me.Label12)
        Me.TabThongtin.Controls.Add(Me.txtMa_KH)
        Me.TabThongtin.Controls.Add(Me.CboQuocGia)
        Me.TabThongtin.Controls.Add(Me.txtTen_KH)
        Me.TabThongtin.Controls.Add(Me.TxtTen_QuocGia)
        Me.TabThongtin.Controls.Add(Me.txtDiaChi)
        Me.TabThongtin.Controls.Add(Me.TxtTaiKhoan)
        Me.TabThongtin.Controls.Add(Me.txtTen_NganHang)
        Me.TabThongtin.Controls.Add(Me.Label16)
        Me.TabThongtin.Controls.Add(Me.TxtDienThoai)
        Me.TabThongtin.Controls.Add(Me.Label15)
        Me.TabThongtin.Controls.Add(Me.TxtFax)
        Me.TabThongtin.Controls.Add(Me.CboNganHang)
        Me.TabThongtin.Controls.Add(Me.DataGridView1)
        Me.TabThongtin.Controls.Add(Me.TxtEmail)
        Me.TabThongtin.Controls.Add(Me.CboNhom)
        Me.TabThongtin.Controls.Add(Me.Label14)
        Me.TabThongtin.Controls.Add(Me.Label7)
        Me.TabThongtin.Controls.Add(Me.Label13)
        Me.TabThongtin.Controls.Add(Me.TxtTen_Nhom)
        Me.TabThongtin.Controls.Add(Me.TxtMST)
        Me.TabThongtin.Controls.Add(Me.TxtCK)
        Me.TabThongtin.Controls.Add(Me.Label11)
        Me.TabThongtin.Controls.Add(Me.TxtVC)
        Me.TabThongtin.Controls.Add(Me.TxtMucNo)
        Me.TabThongtin.Controls.Add(Me.TxtHanNo)
        Me.TabThongtin.Controls.Add(Me.Label10)
        Me.TabThongtin.Controls.Add(Me.Label8)
        Me.TabThongtin.Controls.Add(Me.Label9)
        Me.TabThongtin.Location = New System.Drawing.Point(4, 23)
        Me.TabThongtin.Name = "TabThongtin"
        Me.TabThongtin.Padding = New System.Windows.Forms.Padding(3)
        Me.TabThongtin.Size = New System.Drawing.Size(984, 574)
        Me.TabThongtin.TabIndex = 0
        Me.TabThongtin.Text = "Thông tin"
        '
        'txtDienTich
        '
        Me.txtDienTich.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.txtDienTich.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtDienTich.Location = New System.Drawing.Point(338, 4)
        Me.txtDienTich.MaxLength = 50
        Me.txtDienTich.Name = "txtDienTich"
        Me.txtDienTich.Size = New System.Drawing.Size(180, 22)
        Me.txtDienTich.TabIndex = 1
        '
        'Label29
        '
        Me.Label29.Location = New System.Drawing.Point(269, 5)
        Me.Label29.Name = "Label29"
        Me.Label29.Size = New System.Drawing.Size(66, 22)
        Me.Label29.TabIndex = 122
        Me.Label29.Text = "Diện tích"
        Me.Label29.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label28
        '
        Me.Label28.Location = New System.Drawing.Point(537, 3)
        Me.Label28.Name = "Label28"
        Me.Label28.Size = New System.Drawing.Size(71, 22)
        Me.Label28.TabIndex = 121
        Me.Label28.Text = "DS Phụ trách"
        Me.Label28.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label27
        '
        Me.Label27.Location = New System.Drawing.Point(524, 31)
        Me.Label27.Name = "Label27"
        Me.Label27.Size = New System.Drawing.Size(93, 22)
        Me.Label27.TabIndex = 120
        Me.Label27.Text = "Giấy CN ĐĐKHND"
        Me.Label27.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'Label26
        '
        Me.Label26.Location = New System.Drawing.Point(523, 56)
        Me.Label26.Name = "Label26"
        Me.Label26.Size = New System.Drawing.Size(88, 22)
        Me.Label26.TabIndex = 119
        Me.Label26.Text = "Giấy phép ĐKKD"
        Me.Label26.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'txtDSPhuTrach
        '
        Me.txtDSPhuTrach.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.txtDSPhuTrach.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtDSPhuTrach.Location = New System.Drawing.Point(618, 6)
        Me.txtDSPhuTrach.MaxLength = 50
        Me.txtDSPhuTrach.Name = "txtDSPhuTrach"
        Me.txtDSPhuTrach.Size = New System.Drawing.Size(343, 22)
        Me.txtDSPhuTrach.TabIndex = 2
        '
        'txtChungNhan
        '
        Me.txtChungNhan.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.txtChungNhan.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtChungNhan.Location = New System.Drawing.Point(618, 33)
        Me.txtChungNhan.MaxLength = 50
        Me.txtChungNhan.Name = "txtChungNhan"
        Me.txtChungNhan.Size = New System.Drawing.Size(343, 22)
        Me.txtChungNhan.TabIndex = 4
        '
        'txtDangKy
        '
        Me.txtDangKy.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.txtDangKy.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtDangKy.Location = New System.Drawing.Point(618, 59)
        Me.txtDangKy.MaxLength = 50
        Me.txtDangKy.Name = "txtDangKy"
        Me.txtDangKy.Size = New System.Drawing.Size(343, 22)
        Me.txtDangKy.TabIndex = 6
        '
        'Label23
        '
        Me.Label23.Location = New System.Drawing.Point(34, 140)
        Me.Label23.Name = "Label23"
        Me.Label23.Size = New System.Drawing.Size(61, 19)
        Me.Label23.TabIndex = 115
        Me.Label23.Text = "Nhóm KH"
        Me.Label23.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'txtTenNhom
        '
        Me.txtTenNhom.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTenNhom.Location = New System.Drawing.Point(221, 137)
        Me.txtTenNhom.MaxLength = 50
        Me.txtTenNhom.Name = "txtTenNhom"
        Me.txtTenNhom.Size = New System.Drawing.Size(297, 22)
        Me.txtTenNhom.TabIndex = 114
        '
        'cboMaNhom
        '
        Me.cboMaNhom.ArrowBoxColor = System.Drawing.SystemColors.Control
        Me.cboMaNhom.ArrowColor = System.Drawing.Color.Black
        Me.cboMaNhom.BindedControl = Nothing
        Me.cboMaNhom.BorderStyle = MTGCComboBox.TipiBordi.Fixed3D
        Me.cboMaNhom.CharacterCasing = System.Windows.Forms.CharacterCasing.Normal
        Me.cboMaNhom.ColumnNum = 1
        Me.cboMaNhom.ColumnWidth = "121"
        Me.cboMaNhom.DisabledArrowBoxColor = System.Drawing.SystemColors.Control
        Me.cboMaNhom.DisabledArrowColor = System.Drawing.Color.LightGray
        Me.cboMaNhom.DisabledBackColor = System.Drawing.SystemColors.Control
        Me.cboMaNhom.DisabledBorderColor = System.Drawing.SystemColors.InactiveBorder
        Me.cboMaNhom.DisabledForeColor = System.Drawing.SystemColors.GrayText
        Me.cboMaNhom.DisplayMember = "Text"
        Me.cboMaNhom.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
        Me.cboMaNhom.DropDownBackColor = System.Drawing.Color.FromArgb(CType(CType(193, Byte), Integer), CType(CType(210, Byte), Integer), CType(CType(238, Byte), Integer))
        Me.cboMaNhom.DropDownForeColor = System.Drawing.Color.Black
        Me.cboMaNhom.DropDownStyle = MTGCComboBox.CustomDropDownStyle.DropDown
        Me.cboMaNhom.DropDownWidth = 141
        Me.cboMaNhom.GridLineColor = System.Drawing.Color.LightGray
        Me.cboMaNhom.GridLineHorizontal = False
        Me.cboMaNhom.GridLineVertical = False
        Me.cboMaNhom.LoadingType = MTGCComboBox.CaricamentoCombo.ComboBoxItem
        Me.cboMaNhom.Location = New System.Drawing.Point(101, 138)
        Me.cboMaNhom.ManagingFastMouseMoving = True
        Me.cboMaNhom.ManagingFastMouseMovingInterval = 30
        Me.cboMaNhom.Name = "cboMaNhom"
        Me.cboMaNhom.SelectedItem = Nothing
        Me.cboMaNhom.SelectedValue = Nothing
        Me.cboMaNhom.Size = New System.Drawing.Size(121, 21)
        Me.cboMaNhom.TabIndex = 12
        '
        'Label22
        '
        Me.Label22.Location = New System.Drawing.Point(34, 5)
        Me.Label22.Name = "Label22"
        Me.Label22.Size = New System.Drawing.Size(61, 19)
        Me.Label22.TabIndex = 112
        Me.Label22.Text = "Mã KH"
        Me.Label22.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Label21
        '
        Me.Label21.Location = New System.Drawing.Point(34, 31)
        Me.Label21.Name = "Label21"
        Me.Label21.Size = New System.Drawing.Size(61, 22)
        Me.Label21.TabIndex = 111
        Me.Label21.Text = "Tên KH"
        Me.Label21.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'txtTen
        '
        Me.txtTen.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtTen.Location = New System.Drawing.Point(100, 31)
        Me.txtTen.MaxLength = 100
        Me.txtTen.Name = "txtTen"
        Me.txtTen.Size = New System.Drawing.Size(418, 22)
        Me.txtTen.TabIndex = 3
        '
        'txtMa
        '
        Me.txtMa.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtMa.Location = New System.Drawing.Point(100, 5)
        Me.txtMa.MaxLength = 100
        Me.txtMa.Name = "txtMa"
        Me.txtMa.Size = New System.Drawing.Size(170, 22)
        Me.txtMa.TabIndex = 0
        '
        'Label20
        '
        Me.Label20.Location = New System.Drawing.Point(527, 140)
        Me.Label20.Name = "Label20"
        Me.Label20.Size = New System.Drawing.Size(81, 19)
        Me.Label20.TabIndex = 108
        Me.Label20.Text = "Mã số thuế"
        Me.Label20.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'txtMaSoThue
        '
        Me.txtMaSoThue.AccessibleRole = System.Windows.Forms.AccessibleRole.OutlineButton
        Me.txtMaSoThue.Font = New System.Drawing.Font("Arial", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.txtMaSoThue.Location = New System.Drawing.Point(618, 140)
        Me.txtMaSoThue.MaxLength = 50
        Me.txtMaSoThue.Name = "txtMaSoThue"
        Me.txtMaSoThue.Size = New System.Drawing.Size(343, 22)
        Me.txtMaSoThue.TabIndex = 13
        '
        'TabTimKiem
        '
        Me.TabTimKiem.BackColor = System.Drawing.Color.LightBlue
        Me.TabTimKiem.Controls.Add(Me.Label24)
        Me.TabTimKiem.Controls.Add(Me.txtMaSearch)
        Me.TabTimKiem.Controls.Add(Me.btnTimKiem)
        Me.TabTimKiem.Controls.Add(Me.txtTenSearch)
        Me.TabTimKiem.Controls.Add(Me.Label25)
        Me.TabTimKiem.Controls.Add(Me.gridSearch)
        Me.TabTimKiem.Location = New System.Drawing.Point(4, 22)
        Me.TabTimKiem.Name = "TabTimKiem"
        Me.TabTimKiem.Padding = New System.Windows.Forms.Padding(3)
        Me.TabTimKiem.Size = New System.Drawing.Size(984, 575)
        Me.TabTimKiem.TabIndex = 1
        Me.TabTimKiem.Text = "Tìm kiếm"
        '
        'Label24
        '
        Me.Label24.AutoSize = True
        Me.Label24.Location = New System.Drawing.Point(119, 9)
        Me.Label24.Name = "Label24"
        Me.Label24.Size = New System.Drawing.Size(83, 14)
        Me.Label24.TabIndex = 81
        Me.Label24.Text = "Mã Khách Hàng"
        '
        'txtMaSearch
        '
        Me.txtMaSearch.Location = New System.Drawing.Point(207, 6)
        Me.txtMaSearch.Name = "txtMaSearch"
        Me.txtMaSearch.Size = New System.Drawing.Size(203, 20)
        Me.txtMaSearch.TabIndex = 80
        '
        'btnTimKiem
        '
        Me.btnTimKiem.Location = New System.Drawing.Point(442, 15)
        Me.btnTimKiem.Name = "btnTimKiem"
        Me.btnTimKiem.Size = New System.Drawing.Size(91, 23)
        Me.btnTimKiem.TabIndex = 79
        Me.btnTimKiem.Text = "Tìm kiếm..."
        Me.btnTimKiem.UseVisualStyleBackColor = True
        '
        'txtTenSearch
        '
        Me.txtTenSearch.Location = New System.Drawing.Point(208, 32)
        Me.txtTenSearch.Name = "txtTenSearch"
        Me.txtTenSearch.Size = New System.Drawing.Size(202, 20)
        Me.txtTenSearch.TabIndex = 78
        '
        'Label25
        '
        Me.Label25.AutoSize = True
        Me.Label25.Location = New System.Drawing.Point(119, 35)
        Me.Label25.Name = "Label25"
        Me.Label25.Size = New System.Drawing.Size(87, 14)
        Me.Label25.TabIndex = 77
        Me.Label25.Text = "Tên Khách Hàng"
        '
        'gridSearch
        '
        Me.gridSearch.AutoGenerateColumns = False
        Me.gridSearch.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.gridSearch.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn() {Me.ManhacungcapDataGridViewTextBoxColumn1, Me.TennhacungcapDataGridViewTextBoxColumn1, Me.DiachinhacungcapDataGridViewTextBoxColumn1, Me.MasothueDataGridViewTextBoxColumn1, Me.DienthoaiDataGridViewTextBoxColumn1, Me.FaxDataGridViewTextBoxColumn1, Me.EmailDataGridViewTextBoxColumn1, Me.SotaikhoanDataGridViewTextBoxColumn1, Me.MaquocgiaDataGridViewTextBoxColumn1, Me.MamienDataGridViewTextBoxColumn1, Me.MatinhDataGridViewTextBoxColumn1, Me.MaquanDataGridViewTextBoxColumn1, Me.ManganhangDataGridViewTextBoxColumn1, Me.ManhomDataGridViewTextBoxColumn1, Me.DataGridViewTextBoxColumn1, Me.DataGridViewTextBoxColumn2, Me.DataGridViewTextBoxColumn3, Me.DataGridViewTextBoxColumn4})
        Me.gridSearch.DataMember = "tbl_khachhangSearch"
        Me.gridSearch.DataSource = Me.DataSetSearchBindingSource
        Me.gridSearch.Location = New System.Drawing.Point(4, 58)
        Me.gridSearch.Name = "gridSearch"
        Me.gridSearch.Size = New System.Drawing.Size(977, 513)
        Me.gridSearch.TabIndex = 76
        '
        'ManhacungcapDataGridViewTextBoxColumn1
        '
        Me.ManhacungcapDataGridViewTextBoxColumn1.DataPropertyName = "ma_nhacungcap"
        Me.ManhacungcapDataGridViewTextBoxColumn1.HeaderText = "Mã KH"
        Me.ManhacungcapDataGridViewTextBoxColumn1.Name = "ManhacungcapDataGridViewTextBoxColumn1"
        '
        'TennhacungcapDataGridViewTextBoxColumn1
        '
        Me.TennhacungcapDataGridViewTextBoxColumn1.DataPropertyName = "ten_nhacungcap"
        Me.TennhacungcapDataGridViewTextBoxColumn1.HeaderText = "Tên KH"
        Me.TennhacungcapDataGridViewTextBoxColumn1.Name = "TennhacungcapDataGridViewTextBoxColumn1"
        Me.TennhacungcapDataGridViewTextBoxColumn1.Width = 240
        '
        'DiachinhacungcapDataGridViewTextBoxColumn1
        '
        Me.DiachinhacungcapDataGridViewTextBoxColumn1.DataPropertyName = "diachi_nhacungcap"
        Me.DiachinhacungcapDataGridViewTextBoxColumn1.HeaderText = "Địa chỉ"
        Me.DiachinhacungcapDataGridViewTextBoxColumn1.Name = "DiachinhacungcapDataGridViewTextBoxColumn1"
        Me.DiachinhacungcapDataGridViewTextBoxColumn1.Width = 260
        '
        'MasothueDataGridViewTextBoxColumn1
        '
        Me.MasothueDataGridViewTextBoxColumn1.DataPropertyName = "maso_thue"
        Me.MasothueDataGridViewTextBoxColumn1.HeaderText = "MST"
        Me.MasothueDataGridViewTextBoxColumn1.Name = "MasothueDataGridViewTextBoxColumn1"
        '
        'DienthoaiDataGridViewTextBoxColumn1
        '
        Me.DienthoaiDataGridViewTextBoxColumn1.DataPropertyName = "dienthoai"
        Me.DienthoaiDataGridViewTextBoxColumn1.HeaderText = "ĐT"
        Me.DienthoaiDataGridViewTextBoxColumn1.Name = "DienthoaiDataGridViewTextBoxColumn1"
        '
        'FaxDataGridViewTextBoxColumn1
        '
        Me.FaxDataGridViewTextBoxColumn1.DataPropertyName = "fax"
        Me.FaxDataGridViewTextBoxColumn1.HeaderText = "Fax"
        Me.FaxDataGridViewTextBoxColumn1.Name = "FaxDataGridViewTextBoxColumn1"
        Me.FaxDataGridViewTextBoxColumn1.Width = 50
        '
        'EmailDataGridViewTextBoxColumn1
        '
        Me.EmailDataGridViewTextBoxColumn1.DataPropertyName = "email"
        Me.EmailDataGridViewTextBoxColumn1.HeaderText = "Email"
        Me.EmailDataGridViewTextBoxColumn1.Name = "EmailDataGridViewTextBoxColumn1"
        Me.EmailDataGridViewTextBoxColumn1.Width = 50
        '
        'SotaikhoanDataGridViewTextBoxColumn1
        '
        Me.SotaikhoanDataGridViewTextBoxColumn1.DataPropertyName = "so_taikhoan"
        Me.SotaikhoanDataGridViewTextBoxColumn1.HeaderText = "so_taikhoan"
        Me.SotaikhoanDataGridViewTextBoxColumn1.Name = "SotaikhoanDataGridViewTextBoxColumn1"
        Me.SotaikhoanDataGridViewTextBoxColumn1.Visible = False
        '
        'MaquocgiaDataGridViewTextBoxColumn1
        '
        Me.MaquocgiaDataGridViewTextBoxColumn1.DataPropertyName = "ma_quocgia"
        Me.MaquocgiaDataGridViewTextBoxColumn1.HeaderText = "ma_quocgia"
        Me.MaquocgiaDataGridViewTextBoxColumn1.Name = "MaquocgiaDataGridViewTextBoxColumn1"
        Me.MaquocgiaDataGridViewTextBoxColumn1.Visible = False
        '
        'MamienDataGridViewTextBoxColumn1
        '
        Me.MamienDataGridViewTextBoxColumn1.DataPropertyName = "ma_mien"
        Me.MamienDataGridViewTextBoxColumn1.HeaderText = "Miền"
        Me.MamienDataGridViewTextBoxColumn1.Name = "MamienDataGridViewTextBoxColumn1"
        Me.MamienDataGridViewTextBoxColumn1.Width = 60
        '
        'MatinhDataGridViewTextBoxColumn1
        '
        Me.MatinhDataGridViewTextBoxColumn1.DataPropertyName = "ma_tinh"
        Me.MatinhDataGridViewTextBoxColumn1.HeaderText = "Tỉnh"
        Me.MatinhDataGridViewTextBoxColumn1.Name = "MatinhDataGridViewTextBoxColumn1"
        Me.MatinhDataGridViewTextBoxColumn1.Width = 60
        '
        'MaquanDataGridViewTextBoxColumn1
        '
        Me.MaquanDataGridViewTextBoxColumn1.DataPropertyName = "ma_quan"
        Me.MaquanDataGridViewTextBoxColumn1.HeaderText = "Quận"
        Me.MaquanDataGridViewTextBoxColumn1.Name = "MaquanDataGridViewTextBoxColumn1"
        Me.MaquanDataGridViewTextBoxColumn1.Width = 60
        '
        'ManganhangDataGridViewTextBoxColumn1
        '
        Me.ManganhangDataGridViewTextBoxColumn1.DataPropertyName = "ma_nganhang"
        Me.ManganhangDataGridViewTextBoxColumn1.HeaderText = "ma_nganhang"
        Me.ManganhangDataGridViewTextBoxColumn1.Name = "ManganhangDataGridViewTextBoxColumn1"
        Me.ManganhangDataGridViewTextBoxColumn1.Visible = False
        '
        'ManhomDataGridViewTextBoxColumn1
        '
        Me.ManhomDataGridViewTextBoxColumn1.DataPropertyName = "ma_nhom"
        Me.ManhomDataGridViewTextBoxColumn1.HeaderText = "Nhóm"
        Me.ManhomDataGridViewTextBoxColumn1.Name = "ManhomDataGridViewTextBoxColumn1"
        Me.ManhomDataGridViewTextBoxColumn1.Width = 70
        '
        'DataGridViewTextBoxColumn1
        '
        Me.DataGridViewTextBoxColumn1.DataPropertyName = "dsphutrach"
        Me.DataGridViewTextBoxColumn1.HeaderText = "dsphutrach"
        Me.DataGridViewTextBoxColumn1.Name = "DataGridViewTextBoxColumn1"
        Me.DataGridViewTextBoxColumn1.Visible = False
        '
        'DataGridViewTextBoxColumn2
        '
        Me.DataGridViewTextBoxColumn2.DataPropertyName = "giaychungnhan"
        Me.DataGridViewTextBoxColumn2.HeaderText = "giaychungnhan"
        Me.DataGridViewTextBoxColumn2.Name = "DataGridViewTextBoxColumn2"
        Me.DataGridViewTextBoxColumn2.Visible = False
        '
        'DataGridViewTextBoxColumn3
        '
        Me.DataGridViewTextBoxColumn3.DataPropertyName = "giayphep"
        Me.DataGridViewTextBoxColumn3.HeaderText = "giayphep"
        Me.DataGridViewTextBoxColumn3.Name = "DataGridViewTextBoxColumn3"
        Me.DataGridViewTextBoxColumn3.Visible = False
        '
        'DataGridViewTextBoxColumn4
        '
        Me.DataGridViewTextBoxColumn4.DataPropertyName = "dientich"
        Me.DataGridViewTextBoxColumn4.HeaderText = "dientich"
        Me.DataGridViewTextBoxColumn4.Name = "DataGridViewTextBoxColumn4"
        Me.DataGridViewTextBoxColumn4.Visible = False
        '
        'DataSetSearchBindingSource
        '
        Me.DataSetSearchBindingSource.DataSource = Me.DataSetSearch
        Me.DataSetSearchBindingSource.Position = 0
        '
        'DataSetSearch
        '
        Me.DataSetSearch.DataSetName = "DataSetSearch"
        Me.DataSetSearch.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema
        '
        'frmkhachhang
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
        Me.BackColor = System.Drawing.Color.LightBlue
        Me.ClientSize = New System.Drawing.Size(982, 633)
        Me.Controls.Add(Me.TabMain)
        Me.Controls.Add(Me.Label1)
        Me.Font = New System.Drawing.Font("Arial", 8.25!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
        Me.Name = "frmkhachhang"
        Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
        Me.Text = " Danh Muc Khach Hang"
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetFormDonBindingSource, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetForm_Don, System.ComponentModel.ISupportInitialize).EndInit()
        Me.TabMain.ResumeLayout(False)
        Me.TabThongtin.ResumeLayout(False)
        Me.TabThongtin.PerformLayout()
        Me.TabTimKiem.ResumeLayout(False)
        Me.TabTimKiem.PerformLayout()
        CType(Me.gridSearch, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetSearchBindingSource, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataSetSearch, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region
    Private data1, data2 As DataTable
    Private da As MySqlDataAdapter
    Dim myDT As New DataTable
    Dim strError As String = ""
    Dim myform As Form
    Dim sqlQuery As String = ""
    Sub SetclearData()
        cboMaNhom.Text = ""
        txtTenNhom.Text = ""
        txtMa.Text = ""
        'Khanh Ky 2008 06 13
        'Add
        Me.txtChungNhan.Text = ""
        Me.txtDangKy.Text = ""
        Me.txtDienTich.Text = "0"
        Me.txtDSPhuTrach.Text = ""
        'Khanh Ky 2008 06 13
        'End
        txtTen.Text = ""
        txtMaSoThue.Text = ""
        txtDiaChi.Text = ""
        TxtDienThoai.Text = ""
        TxtFax.Text = ""
        TxtEmail.Text = ""
        CboNganHang.Text = ""
        txtTen_NganHang.Text = ""
        TxtTaiKhoan.Text = ""
        CboQuocGia.Text = ""
        TxtTen_QuocGia.Text = ""
        CboKhuVuc.Text = ""
        TxtTen_KhuVuc.Text = ""
        CboQuan.Text = ""
        TxtTen_Quan.Text = ""
        CboTinh.Text = ""
        TxtTen_Tinh.Text = ""

    End Sub
    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        ' Kiểm tra có nhập liệu chưa ?
        Dim txtMaKH = Me.txtMa.Text.Trim
        Dim txtTenKH = Me.txtTen.Text.Trim
        If Me.checkInput(txtMaKH, txtTenKH) Then
            sqlQuery = "SELECT ma_nhacungcap FROM tbl_khachhang WHERE ma_nhacungcap = '" & txtMaKH & "'"
            Dim existedMamon As Integer = moduleDatabaseConn.CheckRecordExisted(sqlQuery)
            If existedMamon = 1 Then ' Update record
                'Khanh Ky 2008 10 23
                'add 
                moduleConstants.MessageWarning = " Mã khách hàng đã tồn tại , bạn có muốn cập nhật không  ?"
                If MessageBox.Show(moduleConstants.MessageWarning, globalVariale.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = MsgBoxResult.Yes Then
                    If Me.cboMaNhom.Text.Trim = "ALL" Then
                        MessageBox.Show("Không cập nhật được khi chọn Mã Nhóm là ALL !!!")
                        Me.cboMaNhom.Focus()
                    Else
                        sqlQuery = "UPDATE tbl_khachhang "
                        sqlQuery += "SET "
                        sqlQuery += "ma_nhacungcap = '" & txtMaKH & "'"
                        sqlQuery += ", ten_nhacungcap = '" & Me.txtTen.Text.Trim & "'"
                        sqlQuery += ", diachi_nhacungcap = '" & Me.txtDiaChi.Text.Trim & "'"
                        sqlQuery += ", maso_thue = '" & Me.txtMaSoThue.Text.Trim & "'"
                        sqlQuery += ", dienthoai = '" & Me.TxtDienThoai.Text.Trim & "'"
                        sqlQuery += ", fax = '" & Me.TxtFax.Text.Trim & "'"
                        sqlQuery += ", email = '" & Me.TxtEmail.Text.Trim & "'"
                        sqlQuery += ", so_taikhoan = '" & Me.TxtTaiKhoan.Text.Trim & "'"
                        sqlQuery += ", ma_quocgia = '" & Me.CboQuocGia.Text.Trim & "'"
                        sqlQuery += ", ma_mien = '" & Me.CboKhuVuc.Text.Trim & "'"
                        sqlQuery += ", ma_tinh = '" & Me.CboTinh.Text.Trim & "'"
                        sqlQuery += ", ma_quan = '" & Me.CboQuan.Text.Trim & "'"
                        sqlQuery += ", ma_nganhang = '" & Me.CboNganHang.Text.Trim & "'"

                        'Khanh Ky 2008 06 13
                        'Adds
                        sqlQuery += ", dsphutrach = '" & Me.txtDSPhuTrach.Text.Trim & "'"
                        sqlQuery += ", giaychungnhan = '" & Me.txtChungNhan.Text.Trim & "'"
                        sqlQuery += ", giayphep = '" & Me.txtDangKy.Text.Trim & "'"
                        sqlQuery += ", dientich = '" & Me.txtDienTich.Text.Trim & "'"
                        ' End
                        sqlQuery += ", ma_nhom = '" & Me.cboMaNhom.Text.Trim & "'"
                    End If
                    sqlQuery += " WHERE ma_nhacungcap = '" & txtMaKH & "'"
                    Dim updated As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                    If updated = 1 Then
                        'Khanh Ky 2008 11 28
                        'add Cập nhật phần theo dõi thao tac
                        sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                        sqlQuery += "'" & globalVariale.UserLogin & "', "
                        sqlQuery += "'cập nhật', "
                        sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                        sqlQuery += "'Danh Mục Khách Hàng', "
                        sqlQuery += "'" & Me.txtMa.Text & "', "
                        sqlQuery += "'4' ) "
                        moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                        'end
                        MessageBox.Show("Cập nhật thông tin thành công !")
                        sqlQuery = "SELECT * FROM tbl_khachhang where ma_nhom <> 'KT' order by ma_nhacungcap"
                        Me.loadDanhSachKhachhang(sqlQuery)
                    Else
                        'MessageBox.Show("Cập nhật thông tin không thành công: " & globalVariale.sqlMsgError)
                    End If
                    'add
                End If
                'end

            Else
                If existedMamon = 0 Then ' Insert record
                    If Me.cboMaNhom.Text.Trim = "ALL" Then
                        MessageBox.Show("Không cập nhật được khi chọn Mã Nhóm là ALL !!!")
                        Me.cboMaNhom.Focus()
                    Else
                        sqlQuery = "INSERT INTO tbl_khachhang "
                        sqlQuery += "(ma_nhacungcap, ten_nhacungcap,diachi_nhacungcap,maso_thue,dienthoai,fax,"
                        sqlQuery += "email,so_taikhoan,ma_quocgia,ma_mien,ma_tinh,ma_quan,"
                        sqlQuery += "ma_nganhang,dsphutrach,giaychungnhan,giayphep,dientich,ma_nhom) "
                        sqlQuery += "VALUES "
                        sqlQuery += "("
                        sqlQuery += " '" & txtMaKH & "',"
                        sqlQuery += " '" & Me.txtTen.Text.Trim & "',"
                        sqlQuery += "'" & Me.txtDiaChi.Text.Trim & "',"
                        sqlQuery += "'" & Me.txtMaSoThue.Text.Trim & "',"
                        sqlQuery += " '" & Me.TxtDienThoai.Text.Trim & "',"
                        sqlQuery += "'" & Me.TxtFax.Text.Trim & "',"
                        sqlQuery += " '" & Me.TxtEmail.Text.Trim & "',"
                        sqlQuery += " '" & Me.TxtTaiKhoan.Text.Trim & "',"
                        sqlQuery += " '" & Me.CboQuocGia.Text.Trim & "',"
                        sqlQuery += " '" & Me.CboKhuVuc.Text.Trim & "',"
                        sqlQuery += " '" & Me.CboTinh.Text.Trim & "',"
                        sqlQuery += " '" & Me.CboQuan.Text.Trim & "',"
                        sqlQuery += " '" & Me.CboNganHang.Text.Trim & "',"
                        sqlQuery += " '" & Me.txtDSPhuTrach.Text.Trim & "',"
                        sqlQuery += " '" & Me.txtChungNhan.Text.Trim & "',"
                        sqlQuery += " '" & Me.txtDangKy.Text.Trim & "',"
                        sqlQuery += " '" & Me.txtDienTich.Text.Trim & "',"
                        sqlQuery += " '" & Me.cboMaNhom.Text.Trim & "'"
                        sqlQuery += ")"
                    End If
                    Dim inserted As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                    If inserted = 1 Then
                        'Khanh Ky 2008 11 28
                        'add Cập nhật phần theo dõi thao tac
                        sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                        sqlQuery += "'" & globalVariale.UserLogin & "', "
                        sqlQuery += "'Tạo mới', "
                        sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                        sqlQuery += "'Danh Mục Khách Hàng', "
                        sqlQuery += "'" & Me.txtMa.Text & "', "
                        sqlQuery += "'4' ) "
                        moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                        'end
                        MessageBox.Show("Thêm thông tin thành công !")
                        sqlQuery = "SELECT * FROM tbl_khachhang where ma_nhom <> 'KT' order by ma_nhacungcap"
                        Me.loadDanhSachKhachhang(sqlQuery)
                    Else
                        'MessageBox.Show("Thêm thông tin không thành công: " & globalVariale.sqlMsgError)
                    End If
                Else ' SQLExeption: existedMaQuocGia = -1
                    MessageBox.Show("Lấy dữ liệu bị lỗi: " & globalVariale.sqlMsgError, "Lấy dữ liệu", MessageBoxButtons.OK, MessageBoxIcon.Warning)
                End If
            End If
        End If


    End Sub

    Private Sub btnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNew.Click
        SetclearData()
        txtMa.Focus()
    End Sub

    Private Sub btnDelete1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete1.Click
        If Me.txtMa.Text = "" Then
            MessageBox.Show("Bạn chưa chọn Mã để xóa !")
        Else
            moduleConstants.MessageWarning = "Bạn có muốn xóa " & txtMa.Text & " ?"
            If MessageBox.Show(moduleConstants.MessageWarning, globalVariale.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Warning) = MsgBoxResult.Yes Then
                'Khanh Ky 2008 11 28
                'add Cập nhật phần theo dõi thao tac
                sqlQuery = "INSERT INTO tbl_theodoi_thaotac_users (user,thaotac,thoigian,tenbang,maphieu,loaibang) VALUES ("
                sqlQuery += "'" & globalVariale.UserLogin & "', "
                sqlQuery += "'Xóa', "
                sqlQuery += "'" & Format(New DateTime(Now.Year, Now.Month, Now.Day, Now.Hour, Now.Minute, Now.Second), "yyyy-MM-dd hh:mm:ss") & "', "
                sqlQuery += "'Danh Mục Khách Hàng', "
                sqlQuery += "'" & Me.txtMa.Text & "', "
                sqlQuery += "'4' ) "
                moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                'end
                sqlQuery = "DELETE FROM tbl_khachhang WHERE ma_nhacungcap = '" & txtMa.Text & "'"
                Dim deleting As Integer = moduleDatabaseConn.ExecuteNonQuery(sqlQuery)
                If deleting = 1 Then
                    MessageBox.Show("Xóa thông tin thành công !")
                    sqlQuery = "SELECT * FROM tbl_khachhang where ma_nhom <> 'KT' order by ma_nhacungcap"
                    Me.loadDanhSachKhachhang(sqlQuery)
                    SetclearData()
                Else
                    MessageBox.Show("Xóa thông tin không thành công: " & globalVariale.sqlMsgError)
                End If
            End If
        End If
    End Sub
    Private Sub frmkhachhang_load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
        SetclearData()
        Me.loadDanhSachNhomKH()
        Me.loadDanhSachNhomNganHang()
        Me.loadDanhSachNhomQuocGia()
        Me.loadDanhSachNhomKhuVuc()
        Me.loadDanhSachNhomTinh()
        Me.loadDanhSachNhomQuan()
        moduleUtils.setDinhDangVietNam()
        Me.loadDanhSachKhachhang("SELECT * FROM tbl_khachhang where ma_nhom <> 'KT' order by ma_nhacungcap")
    End Sub

    Private Sub BtnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnClose.Click
        Me.Close()
    End Sub
    Function checkInput(ByVal maLop As String, ByVal tenLop As String) As Boolean
        Dim result As Boolean = True
        If maLop = "" Then
            MessageBox.Show("Bạn chưa chọn Mã Khách hàng !")
            result = False
        Else
            If tenLop = "" Then
                MessageBox.Show("Bạn chưa nhập tên Khách hàng!")
                result = False
            End If
        End If
        Return result
    End Function
    Private Sub loadDanhSachKhachhang(ByVal sqlQuery As String)
        Me.DataGridView1.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
    End Sub
    Private Sub loadDanhSachNhomKH()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_nhom_khachhang, ten_nhom_khachhang FROM tbl_nhom_khachhang where ma_nhom_khachhang <> 'KT' ORDER BY ma_nhom_khachhang"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        cboMaNhom.Items.Clear()
        cboMaNhom.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        cboMaNhom.ColumnNum = 2
        cboMaNhom.ColumnWidth = "100;250"
        cboMaNhom.HighlightBorderColor = Color.Black
        cboMaNhom.GridLineHorizontal = True
        cboMaNhom.GridLineVertical = True
        cboMaNhom.ItemHeight = 17
        cboMaNhom.DropDownHeight = 300
        cboMaNhom.SourceDataTable = data2
        cboMaNhom.SelectedIndex = 0
    End Sub
    Private Sub CboNhom_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboNhom.SelectedIndexChanged
        Me.TxtTen_Nhom.Text = Me.CboNhom.SelectedItem.Col2
    End Sub
    Private Sub loadDanhSachNhomNganHang()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_nganhang, ten_nganhang FROM tbl_nganhang ORDER BY ma_nganhang"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboNganHang.Items.Clear()
        CboNganHang.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboNganHang.ColumnNum = 2
        CboNganHang.ColumnWidth = "100;250"
        CboNganHang.HighlightBorderColor = Color.Black
        CboNganHang.GridLineHorizontal = True
        CboNganHang.GridLineVertical = True
        CboNganHang.ItemHeight = 17
        CboNganHang.DropDownHeight = 300
        CboNganHang.SourceDataTable = data2
        CboNganHang.SelectedIndex = 0
    End Sub
    Private Sub CboNganHang_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboNganHang.SelectedIndexChanged
        Me.txtTen_NganHang.Text = Me.CboNganHang.SelectedItem.Col2
    End Sub
    Private Sub loadDanhSachNhomQuocGia()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_quocgia, ten_quocgia FROM tbl_quocgia ORDER BY ma_quocgia"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboQuocGia.Items.Clear()
        CboQuocGia.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboQuocGia.ColumnNum = 2
        CboQuocGia.ColumnWidth = "100;250"
        CboQuocGia.HighlightBorderColor = Color.Black
        CboQuocGia.GridLineHorizontal = True
        CboQuocGia.GridLineVertical = True
        CboQuocGia.ItemHeight = 17
        CboQuocGia.DropDownHeight = 300
        CboQuocGia.SourceDataTable = data2
        CboQuocGia.SelectedIndex = 0
    End Sub
    Private Sub CboQuocGia_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboQuocGia.SelectedIndexChanged
        Me.TxtTen_QuocGia.Text = Me.CboQuocGia.SelectedItem.Col2
    End Sub
    Private Sub loadDanhSachNhomKhuVuc()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_mien, ten_mien FROM tbl_mien ORDER BY ma_mien"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboKhuVuc.Items.Clear()
        CboKhuVuc.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboKhuVuc.ColumnNum = 2
        CboKhuVuc.ColumnWidth = "100;250"
        CboKhuVuc.HighlightBorderColor = Color.Black
        CboKhuVuc.GridLineHorizontal = True
        CboKhuVuc.GridLineVertical = True
        CboKhuVuc.ItemHeight = 17
        CboKhuVuc.DropDownHeight = 300
        CboKhuVuc.SourceDataTable = data2
        CboKhuVuc.SelectedIndex = 0
    End Sub
    Private Sub CboKhuVuc_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboKhuVuc.SelectedIndexChanged
        Me.TxtTen_KhuVuc.Text = Me.CboKhuVuc.SelectedItem.Col2
        sqlQuery = "SELECT ma_tinh, ten_tinh FROM tbl_tinh where ma_mien ='" & Me.CboKhuVuc.Text & "'  ORDER BY ma_tinh"
        CboTinh.Items.Clear()
        CboTinh.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboTinh.ColumnNum = 2
        CboTinh.ColumnWidth = "100;250"
        CboTinh.HighlightBorderColor = Color.Black
        CboTinh.GridLineHorizontal = True
        CboTinh.GridLineVertical = True
        CboTinh.ItemHeight = 17
        CboTinh.DropDownHeight = 300
        Me.CboTinh.SourceDataTable = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboTinh.SelectedIndex = -1

        Dim sqlQuery1 As String = "SELECT ma_quan, ten_quan FROM tbl_quan where ma_tinh ='" & Me.CboTinh.Text & "'  ORDER BY ma_quan"
        CboQuan.Items.Clear()
        CboQuan.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboQuan.ColumnNum = 2
        CboQuan.ColumnWidth = "100;250"
        CboQuan.HighlightBorderColor = Color.Black
        CboQuan.GridLineHorizontal = True
        CboQuan.GridLineVertical = True
        CboQuan.ItemHeight = 17
        CboQuan.DropDownHeight = 300
        Me.CboQuan.SourceDataTable = moduleDatabaseConn.GetDataTable(sqlQuery1)
        CboQuan.SelectedIndex = -1
    End Sub
    Private Sub loadDanhSachNhomTinh()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_tinh, ten_tinh FROM tbl_tinh where ma_mien ='" & Me.CboKhuVuc.Text & "'  ORDER BY ma_tinh"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboTinh.Items.Clear()
        CboTinh.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboTinh.ColumnNum = 2
        CboTinh.ColumnWidth = "100;250"
        CboTinh.HighlightBorderColor = Color.Black
        CboTinh.GridLineHorizontal = True
        CboTinh.GridLineVertical = True
        CboTinh.ItemHeight = 17
        CboTinh.DropDownHeight = 300
        CboTinh.SourceDataTable = data2
        CboTinh.SelectedIndex = 0
    End Sub
    Private Sub CboTinh_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboTinh.SelectedIndexChanged
        Me.TxtTen_Tinh.Text = Me.CboTinh.SelectedItem.Col2
        'khanh ky 23 05 2008
        Dim sqlQuery1 As String = "SELECT ma_quan, ten_quan FROM tbl_quan where ma_tinh ='" & Me.CboTinh.Text & "'  ORDER BY ma_quan"
        CboQuan.Items.Clear()
        CboQuan.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboQuan.ColumnNum = 2
        CboQuan.ColumnWidth = "100;250"
        CboQuan.HighlightBorderColor = Color.Black
        CboQuan.GridLineHorizontal = True
        CboQuan.GridLineVertical = True
        CboQuan.ItemHeight = 17
        CboQuan.DropDownHeight = 300
        Me.CboQuan.SourceDataTable = moduleDatabaseConn.GetDataTable(sqlQuery1)
        CboQuan.SelectedIndex = -1
        'khanh ky 23 05 2008
    End Sub
    Private Sub loadDanhSachNhomQuan()
        Dim sqlQuery As String = ""
        sqlQuery = "SELECT ma_quan, ten_quan FROM tbl_quan where ma_tinh ='" & Me.CboTinh.Text & "'  ORDER BY ma_quan"
        data2 = moduleDatabaseConn.GetDataTable(sqlQuery)
        CboQuan.Items.Clear()
        CboQuan.LoadingType = MTGCComboBox.CaricamentoCombo.DataTable
        CboQuan.ColumnNum = 2
        CboQuan.ColumnWidth = "100;250"
        CboQuan.HighlightBorderColor = Color.Black
        CboQuan.GridLineHorizontal = True
        CboQuan.GridLineVertical = True
        CboQuan.ItemHeight = 17
        CboQuan.DropDownHeight = 300
        CboQuan.SourceDataTable = data2
        CboQuan.SelectedIndex = 0
    End Sub

    Private Sub CboQuan_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles CboQuan.SelectedIndexChanged
        Me.TxtTen_Quan.Text = Me.CboQuan.SelectedItem.Col2
    End Sub

    Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick

        If e.RowIndex >= 0 And e.ColumnIndex >= 0 Then
            Dim iRow As Integer = Me.DataGridView1.CurrentRow.Index
            Me.txtMa.Text = Me.DataGridView1.Item(0, iRow).Value
            Me.txtTen.Text = Me.DataGridView1.Item(1, iRow).Value
            Me.txtDiaChi.Text = Me.DataGridView1.Item(2, iRow).Value
            Me.txtMaSoThue.Text = Me.DataGridView1.Item(3, iRow).Value
            Me.TxtDienThoai.Text = Me.DataGridView1.Item(4, iRow).Value
            Me.TxtFax.Text = Me.DataGridView1.Item(5, iRow).Value
            Me.TxtEmail.Text = Me.DataGridView1.Item(6, iRow).Value

            Me.TxtTaiKhoan.Text = Me.DataGridView1.Item(7, iRow).Value
            Me.CboQuocGia.Text = Me.DataGridView1.Item(8, iRow).Value
            Me.CboKhuVuc.Text = Me.DataGridView1.Item(9, iRow).Value
            Me.CboTinh.Text = Me.DataGridView1.Item(10, iRow).Value
            Me.CboQuan.Text = Me.DataGridView1.Item(11, iRow).Value

            Me.CboNganHang.Text = Me.DataGridView1.Item(12, iRow).Value
            Me.cboMaNhom.Text = Me.DataGridView1.Item(13, iRow).Value
            Me.txtDSPhuTrach.Text = Me.DataGridView1.Item(14, iRow).Value
            Me.txtChungNhan.Text = Me.DataGridView1.Item(15, iRow).Value
            Me.txtDangKy.Text = Me.DataGridView1.Item(16, iRow).Value
            Me.txtDienTich.Text = Me.DataGridView1.Item(17, iRow).Value
        End If



    End Sub

    Private Sub BtnIn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnIn.Click
        FrmCrKhachHang.Show()
    End Sub

    Private Sub cboMaNhom_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboMaNhom.SelectedIndexChanged
        Me.txtTenNhom.Text = Me.cboMaNhom.SelectedItem.Col2

        If Me.cboMaNhom.Text.Trim = "ALL" Then
            sqlQuery = " select * from tbl_khachhang where ma_nhom <> 'KT' "
            Me.DataGridView1.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
        Else
            sqlQuery = " select * from tbl_khachhang where ma_nhom ='" & Me.cboMaNhom.Text & "'"
            Me.DataGridView1.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
        End If
    End Sub

    Private Sub btnTimKiem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTimKiem.Click
        If Me.txtMaSearch.Text = "" And Me.txtTenSearch.Text = "" Then
            MessageBox.Show("Bạn phải nhập thông tin tìm kiếm !!!")
            Me.txtMaSearch.Focus()
        Else
            sqlQuery = "SELECT *  FROM tbl_khachhang "
            sqlQuery += " where ma_nhacungcap like '%" & Me.txtMaSearch.Text & "%'"
            sqlQuery += " and  ten_nhacungcap like '%" & Me.txtTenSearch.Text & "%'"
            sqlQuery += " and  ma_nhom <> 'KT'"
            Me.gridSearch.DataSource = moduleDatabaseConn.GetDataTable(sqlQuery)
        End If
    End Sub
    Public Sub loadToFormThongTin_kh(ByVal txtMakhach As String)
        sqlQuery = "SELECT ma_nhacungcap, ten_nhacungcap,diachi_nhacungcap,maso_thue,dienthoai,fax, "
        sqlQuery += "email,so_taikhoan,ma_quocgia,ma_mien,ma_tinh,ma_quan, "
        sqlQuery += "ma_nganhang,dsphutrach,giaychungnhan,giayphep,dientich,ma_nhom  "
        sqlQuery += " FROM tbl_khachhang "
        sqlQuery += " where ma_nhacungcap = '" & txtMakhach & "'"
        Dim tmp As DataTable = moduleDatabaseConn.GetDataTable(sqlQuery)
        Try
            Me.txtMa.Text = txtMakhach
            Me.txtTen.Text = tmp.Rows.Item(0).Item(1)
            Me.txtDiaChi.Text = tmp.Rows.Item(0).Item(2)
            Me.txtMaSoThue.Text = tmp.Rows.Item(0).Item(3)
            Me.TxtDienThoai.Text = tmp.Rows.Item(0).Item(4)
            Me.TxtFax.Text = tmp.Rows.Item(0).Item(5)
            Me.TxtEmail.Text = tmp.Rows.Item(0).Item(6)

            Me.TxtTaiKhoan.Text = tmp.Rows.Item(0).Item(7)
            Me.CboQuocGia.Text = tmp.Rows.Item(0).Item(8)
            Me.CboKhuVuc.Text = tmp.Rows.Item(0).Item(9)
            Me.CboTinh.Text = tmp.Rows.Item(0).Item(10)
            Me.CboQuan.Text = tmp.Rows.Item(0).Item(11)

            Me.CboNganHang.Text = tmp.Rows.Item(0).Item(12)
            Me.txtDSPhuTrach.Text = tmp.Rows.Item(0).Item(13)
            Me.txtChungNhan.Text = tmp.Rows.Item(0).Item(14)
            Me.txtDangKy.Text = tmp.Rows.Item(0).Item(15)
            Me.txtDienTich.Text = tmp.Rows.Item(0).Item(16)
            Me.cboMaNhom.Text = tmp.Rows.Item(0).Item(17)
        Catch ex As Exception

        End Try

    End Sub
    Private Sub gridSearch_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles gridSearch.DoubleClick
        Me.TabMain.SelectedTab = Me.TabThongtin
        Dim iRow As Integer = Me.gridSearch.CurrentRow.Index
        Me.txtMa.Text = Me.gridSearch.Item(0, iRow).Value
        Me.txtTen.Text = Me.gridSearch.Item(1, iRow).Value
        Me.txtDiaChi.Text = Me.gridSearch.Item(2, iRow).Value
        Me.txtMaSoThue.Text = Me.gridSearch.Item(3, iRow).Value
        Me.TxtDienThoai.Text = Me.gridSearch.Item(4, iRow).Value
        Me.TxtFax.Text = Me.gridSearch.Item(5, iRow).Value
        Me.TxtEmail.Text = Me.gridSearch.Item(6, iRow).Value

        Me.TxtTaiKhoan.Text = Me.gridSearch.Item(7, iRow).Value
        Me.CboQuocGia.Text = Me.gridSearch.Item(8, iRow).Value
        Me.CboKhuVuc.Text = Me.gridSearch.Item(9, iRow).Value
        Me.CboTinh.Text = Me.gridSearch.Item(10, iRow).Value
        Me.CboQuan.Text = Me.gridSearch.Item(11, iRow).Value

        Me.CboNganHang.Text = Me.gridSearch.Item(12, iRow).Value
        Me.cboMaNhom.Text = Me.gridSearch.Item(13, iRow).Value
        Me.txtDSPhuTrach.Text = Me.gridSearch.Item(14, iRow).Value
        Me.txtChungNhan.Text = Me.gridSearch.Item(15, iRow).Value
        Me.txtDangKy.Text = Me.gridSearch.Item(16, iRow).Value
        Me.txtDienTich.Text = Me.gridSearch.Item(17, iRow).Value

    End Sub
End Class


